Example URL for Corrections Corporation of America Lobbying Group
I’d like to pull info from this URL straight into R for extraction. Specifically I want the names of the individuals associated with different lobbying groups.
str(request)
List of 6
$ url : chr "http://media.ethics.ga.gov/search/Lobbyist/Lobbyist_Groupsearchresults.aspx?&Year=2006%20and%20Newer&GroupName=Corrections&Grou"| __truncated__
$ status_code: int 200
$ headers : raw [1:342] 48 54 54 50 ...
$ modified : POSIXct[1:1], format: NA
$ times : Named num [1:6] 0 0.015 0.046 0.046 0.109 0.187
..- attr(*, "names")= chr [1:6] "redirect" "namelookup" "connect" "pretransfer" ...
$ content : raw [1:27303] 0d 0a 0d 0a ...sample(request$content,200) [1] 20 74 29 3e 72 20 6f 4c 6d 63 30 63 4e 22 32 67 41 6d 28 61 6e 65 6c
[24] 2e 66 61 20 73 6d 2b 20 31 74 22 3e 5f 31 69 29 5f 79 20 52 69 47 68
[47] 22 4f 61 72 65 3e 69 62 68 67 3e 3c 0d 70 22 74 64 20 2e 23 65 76 22
[70] 6c 6c 32 72 6f 73 20 4e 76 61 57 63 20 74 3c 6c 47 74 65 28 59 68 6c
[93] 20 62 31 29 6f 6c 65 76 22 32 65 72 6c 22 2e 20 72 20 20 6c 3e 74 69
[116] 46 75 65 78 28 4d 63 73 3c 65 0d 5f 6c 6e 65 73 33 71 20 3c 74 72 20
[139] 79 66 35 50 67 25 6e 71 61 43 69 34 68 20 62 6c 20 72 20 64 70 79 7b
[162] 48 69 75 69 5a 76 76 74 73 4c 65 69 0d 73 72 73 72 69 41 7d 69 20 65
[185] 09 69 73 20 20 65 73 3d 61 32 69 20 61 52 38 62Looks like it’s sending data in bytes
parse_headers(request$headers) [1] "HTTP/1.1 200 OK"
[2] "Cache-Control: private"
[3] "Content-Type: text/html; charset=utf-8"
[4] "Content-Encoding: gzip"
[5] "Vary: Accept-Encoding"
[6] "Server: Microsoft-IIS/7.5"
[7] "Set-Cookie: ASP.NET_SessionId=iojmsqz4e0ahiu452htk5345; path=/; HttpOnly"
[8] "X-AspNet-Version: 2.0.50727"
[9] "X-Powered-By: ASP.NET"
[10] "Date: Tue, 13 Dec 2016 20:37:07 GMT"
[11] "Content-Length: 9178" library(xlsx)
PAC<- read.xlsx("C:/git/galegis/Data/PAC_List.xls",
sheetIndex=1)Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, :
java.lang.IllegalArgumentException: Your InputStream was neither an OLE2 stream, nor an OOXML streamstr(PAC)
'data.frame': 624 obs. of 16 variables:
$ NameID : int 7184 20320 3253 2735 23642 349 3041 25923 5508 25931 ...
$ FilerID : chr "NC2010000038" "NC2014000002" "NC2007000554" "NC2006000437" ...
$ CommitteeType : chr "Political Action Committee" "Political Action Committee" "Political Action Committee" "Political Action Committee" ...
$ CommitteeName : chr "Atlanta & North GA Building Trades Council" "Georgia Academy of Family Physicians Political Action Committee" "2007 SPLOST Campaign" "21st Century Democrats" ...
$ Address : chr "501 Pulliam Street, Suit 511" "3760 Lavista Road Suite 100" "2003 Rose Ave" "1731 Connecticut Ave NW 2nd Fl" ...
$ Address2 : chr "" "" "" "" ...
$ City : chr "Atlanta" "Tucker" "Americus" "Washington" ...
$ State : chr "GA" "GA" "GA" "DC" ...
$ Zip : chr "30312" "30084" "31709" "20009" ...
$ Telephone : chr "4045840005" "4043217445" "2299243304" "2026266193" ...
$ Chairperson : chr "Randy Beall" "Wayne Hoffman, MD" "John H Snyder" "Kelly Young" ...
$ ChairpersonAddress: chr "501 Pulliam Street, Suit 511" "3760 Vista Road, Suite 100" "2003 Rose Ave" "1731 Connecticut Ave NW 2nd Fl" ...
$ ChairpersonCSZ : chr "Atlanta, GA 30312" "Tucker, GA 30084" "Americus, GA 31709" "Washington, D C 20009" ...
$ Treasurer : chr "Randy Beall" "Fay Fulton" "John H Snyder" "Bill Combs" ...
$ TreasurerAddress : chr "501 Pulliam Street, Suit 511" "3760 Lavista Road Suite 100" "2003 Rose Ave" "1731 Connecticut Ave NW 2nd Fl" ...
$ TreasurerCSZ : chr "Atlanta, GA 30312" "Tucker, GA 30084" "Americus, GA 31709" "Washington, D C 20009" ...If we can figure out how to pull down the HTML page for inspection, that will be a quick way to pull the names.
sample(example,50)
[1] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">11675 GREAT OAKS WAY</span><span><br /></span><span class=\"lblentry\">ALPHARETTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30022</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[2] " </tr>"
[3] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl09_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[4] "</head>"
[5] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl07_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl07$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[6] "<body>"
[7] " <h4 style=\"margin-left:145px; margin-top:75px;\"><span id=\"ctl00_ContentPlaceHolder1_lblMessage\" style=\"display:inline-block;width:100%;\">LOBBYIST SEARCH - BY GROUP RESULTS FOR 2006 AND NEWER</span></h4> "
[8] " <td class=\"style219\">Search Lobbyist </td>"
[9] "}"
[10] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[11] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl22_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">TURNER</span>"
[12] " </td>"
[13] "display: block;"
[14] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl18_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[15] " <table>"
[16] " "
[17] " urchinTracker();"
[18] " </td>"
[19] " "
[20] " <tr>"
[21] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">151 FARMINGTON AVENUE, MAIL STOP RC61</span><span><br /></span><span class=\"lblentry\">HARTFORD</span><span class=\"lblentry\">,</span><span class=\"lblentry\">CT</span><span class=\"lblentry\"> </span><span class=\"lblentry\">06156</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[22] "border-bottom-width: 0;"
[23] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl13_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">FORTSON</span>"
[24] ""
[25] "z-index:100;"
[26] " <table style=\"text-align:center; margin: 0 auto; width:100%\">"
[27] "<input type=\"hidden\" name=\"__VIEWSTATE\" id=\"__VIEWSTATE\" value=\"wtpNxoDdPXrPdEz1G2jrnPfRXgTsGz3x5H6p/YCj6ljXFVFswwWcd/Om+/RRP04+EfnKDGU2hIKhYe+1Yx9Zw98wvVq6AgySwVmIWhOzeS5leUBu6vccbOhQzcOhm4pEdY4FIupv9IP8lNt/E5n48YXOBTnV0M1tjK2iZQmeKSXuAaTgKJ1XeBDRuq1RUMXSMdPIeZ7YzD69Bm5V/vzA9VJwFT/7v3B6va5FQAfXlFx/+m5aQqIIUyUqUPoYtu5YuVCcNGgyB3XVrScL+0j8kkCJqOPF/Whq05QmVo0TnJ3nK5I7wnK97SbLTj1klGJ6wuW4HTDfJF0kiNv9DdeksLjhU0HI6ndtJEWgeqMnqrlUCvjIlMyxHhL531Et0AgOfhAtDjMlzEYEDWDy+KuNHogJtzNTL3Ju8NevHJv3JqDebsb/OzWSGQk1Lf2H+r9gxLbfAqJGBEM5FDiPNNQUzsqAlhrKEY8KkfKR39/uy0cTqXo2rhqAJZubQb73PJTvSG7EesaeKhKKhF1QVgJI9JYdHiVAGgxtXW5DZFqlGl1sv6LT9TOp5GoIWnuPFj0oYOw5S0zwmHYdd6QDmxcaO4Krbaf65+F0NbPbwJZE8pYehRHcep9R/z9bWkK8OGxDzRgukBaDgdrpLHRTNlqIffSh7goun6PdBLjrEF5cRRXC5d9dDrgVoZ2dmkM6VopX0qROFfA9RNXAGAKjwkZ71r+gfYzN2l7yUJYM0Ix2DM9UZVVQagyXPjO0Ke20W4CRD5Psh0hHxWwT9sqlJek/Iw6mDSWxw4hU4tOSaUBk62kTCFZaxFp0XfhMCW4TRLRrbLsmJtPCy2B0rOZNd6B3iVivXsxB0PREVEJqnWxKf3XHv2eLAVuTVOwrmD9gOkzGBPcPUS8I8ntPk2DqWqkdZK2avIMxjxUyPgQ0uzx/YMw6i0+qD31bAZo4m4dheXaQ6vteiBxLlVBOy+5LDsG1hgot4yubntbWk6Qn8WJfXtYPKi1eYRefLiofKxGiZmW+Djscj+loEs8usTeVA7WSz4JD4D34VAXwSzEEq5892Dl6iQhV58afcMUBW5VyX+U8d0AWYBk7x1Bl/rALlA8HXDxbOcKxo9JkHHJI9LfxCEWU8RN8E4wQ+eUcDPimd/FvddoV9oWvN2AQwYpOVzdJbKcWh+6n/j7/9Sx6cn/zQAzLyxMHYRfap3MieB25i9yb94iIoJ8awvqU5jMz6Xbnpp5M64WeolSo2SVkt2wf9+D3Co7x/bxz+0uFFnK2f7KkJ/CIuune6DHt+PIp7Tnp1L4ww4wq8o58QCZHOWARu/9dl6JRekueIws788EH8PvcAtwbsxCn5AY73YMB7V5IcYEbbxzzv4OJdiDHpINgjZVmBj6HL4Wd3qaY+nFWI9bRA5Rspi5muq1rHBi30tW+DwGFig0KaGFfcVMjWvYgiMFmNzM7ppV4b5uab3XWcP8WpYCwKmXRxlf0tgmTT3UIyFfpglBMD/ohAQUFLNwbubugOzSziS5en71iLzfMB5tmTv+skoExAY0hmQDnjAQZtG4XlJ4pu22HsCV1jA3auN2ZRKv+xtw5hxUehYYBhB7439ObIxd19Tg13dPqxxyYqnZ7ItxgtCFEXMULjt3DiAhFIw02JBJOL2IUQ4ZaX0zzJlT25HL5vWmEuplMEGnb4poHwqE/It6eWZdYFjvhuquHL3L1VDAS1KjLkimLFBVDNK59ZxsIzQ9/NH5A6LfmBw6nyqtgbc5NbP2a7JOuHQEjZhYkiuvURnvRbeJStOvRMMMgbTfvakssrSArAimhK2m+mmxtzAWgGKcXND+Oi+TA9q0xB+uuFF30lvJOTCMv1goQBvAMtZk9PVx/IpM8QX/jJ4TQRnY0pwZGWrob6O3CUkyQ41vos0U0+8Qmxw2y+nONjB2pt2loga5byIzTLcx8YoY0ERAN3nLa284hWzjhAwZtZtMUp00+g6BFCjSJWvyujgo+Fz3DIgTsxf5isA7VrsvDdHD1koT2/3ZWbCsoA7dqfH5CJRwmmqbREWwQgA8239Fwemi3cJVEvGv599PA0Tmdp94a5DWz+VKJc7QJaNDk2mYjvLmqHCVX0IJbqLmYQgHotLFFCLcgDTO18Lifi8Ga/Ao2+OQZ5d4EUK1nNz+zUbu3drPp9zd823dLz3q++r/7WmnJxvSjPDQJ6gX4C5XZuF1xTRm3YF4lyUh/HvyBIxRKUd1onJ567dul0Wfmoiypsc1GtDGhJW3dF8tSx8UguGQvXXKIV8oZfy3sY8KY5tmXC/zt9L+Uo3nDCpBH8fl2n8ggTulNacM1Zi7B/UzbDbtYjmm0xBPvwry+0478L5ajnAMKSGrQUAaJn1etG5adWpX7NkWza8/Vc1rKYMXGVFcbl8NcjqQdQJxjw8Z9dcybWQUcJVGF/ZruP1B28dtG8COzn7wv+ctCK071kiIXUfgS67144RaCGM6lbko+lm0ZLubKkdaAYZJ4PpblTMjnyCZxn9e2dkHPhkZz2QugIS7jK1C6KTJXOhd1VCFROEOKA8byBdOOAFkVdCtiV20r8y4gQimCovyGpAQikNR+H1HFntQg0mm/Q0FtbME3yCSVyE+5yHMm/rlBRQAPEFsqVclypTt49KGirj7xneihtZoXbz2vJ57c5KW5Foqdyot8QTo7ohHpqMcnjph2+MpPDdcGa7AsPzcqoLt6LhIvdth+ANAO6vq+sttOioOYzurhvJPL8M+2zmzkDyE2C43xwvQ4PJ2xbf8+NAssGRZ+Mf87fyDKGHOlsf9vZngUwQeP6ZypU0jqhS92LmVdAiZ17wwWufe2dGPrpMhVfnjXr60HsdZ+l4HJ2PX3hkg9CtFkyz/EFMD89YJfZBdKTbo4ZqYm+zlvseNkLvYMOtv8xvyrBYj0g/4fKySz0maHvhvgVrG/f2uPn277zGGvveluFmCCIMdxuOlzSQnDlGhUBtkR0tEWT0HUjUYssrCFKFi4y4jo/BixWMttihMoXBBGFrGKLFFN3t5J3Bcqby0truxh4UnFV8ko3K7aInT7qDYX71JB77yENXVE2Mlhw7OcA2tlcAqAb/2//LPPSE0bMPWWfPXCW1a9kimtco78My695cvOoyKkMcqHuhHN+zbkoKuAF/qu4tTs7ku1V4IvaECd/XhLGjxzb+eaXJJdP6SpbcYWxRlwczNX0x+A7tuk4fiOw01m03Yb0QYZTxD+kev4Rwi+/RHS4+JnWRqYshreb5cYiEepfO45yp1w0HkB5cvk1Fra5P7fVoMRSnio1JZ19Zz9TEz5e0e7BbyG4NSLl08FpCX/PwaX5MCLF4gxj070H3ihcqtjj4cs0Eb29tFF4CHMtwpD7yu8ge/+mcJ3jkxvOtCMise9fVpingPbDjB11bbNUpX+TqBINd6x5ABua83603R3jcVOOo7Xhp9JKQc9s9WEk8ax22ADUu8SM2kdMP0xhQWXug9eWl9Yxe12BRkdmGzYkY5MOJ/edLqndIXLJ26UDsCQrc8H6WU9SI/4CAE3ehP1UHOTMQtkbTh0N/EFk9IogMCUdXfQLZrZ/5e5z5F6ZlfiCgC0e02gztCVoAuneNTWSMB3RcwcSgRULTAgca3tz52mZLsmkLwMlMvAduTCP7ZKdDH9cxqf/OLOCF9FdYnng4a2eaTlex4sj6QbEdW+gEpWdyU51z96VnWevnw/KUmRQGd0wclUaRBVLRUNkL2nrcrnsfc6LVxoeBWt3IzNZbDjiXTVE5mBwqqTRVF8ZsLqG48PY284aLQ33tDYhVCOyEifejg6aHFTHy2kDray3PpeFB+l4vNrWuG2tfVgzB0jsGR7fFVRbi6VRtvfNiDxF9EzJGPfGWC9fgACyUG78skaRbxUaLXlsWbsP9BlI0CmTippMYUFp34HCrH08IXcYfL13y78IBS/n/MItVNkJ3ZZzPu+qsUPSVZqQJujNDrC3NrdJuV2rvSKn3efMjAOGKcp3B2DInve+ZN6DGehsYFIsZuK864wYVx4DPLN2YJDMT8Li4QFH5pI+tSbx7r+kyJjDAohpqjHXEW6lGvJEnDdX/PIPUrF/529j0bgow/PxSoIfN5bGvFOfv+hZzA/miMWUp4ajbOgtYuTSLQ17hGsfUqN8EWGP+Ov7kJy1+Ch/MOq7N5jmlRCTuWCIshTOE36h1TsQCXT7IiP/C5vwimH5S1CsC6GvroEqv1o7pjcLfzj6GkyXVczgu91PbdK2l1XFaEsMMn6TxGO5KzOKTxT30w9QWMl7cD7X1nxDyD7gx2TN7KK8foinYIEdLV2U1WqeEfGQ1umstiHbwj6OCfMbW4tWx3opA82Pna77AoncqpfmTwxkAbzbcJTkSoviaY8F94ycAs//ItNgMoRpus4OQKRxEp3C+kwMnH7xSdn6qyBziQRmkvG/2bLSp3QRPpovn+66F+9Qq5ISU5Zf/sP5CYbL86BgdO7Vp/nOA+HqSXBLePGDaML+AlxPkgHUOPrHzhPooWfsCUWmO0HEKYBEo6+X5bhVspnY83BDknLvD1nxt6V8fA7hplYNvxnbHX3qF8=\" />"
[28] " <td class=\"style218\"> </td>"
[29] "\t\t</tr><tr class=\"gridviewalterrow\" style=\"height:55px;\">"
[30] " <td class=\"quicklinks\"><a href=\"/search/ReportSummary.aspx\">CFC Main Search</a></td>"
[31] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl18_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl18$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[32] " <td class=\"quicklinks\"><a href=\"/search/Business/Business_Transaction_Search.aspx\" rel=\"nofollow\" title=\"Search Business Transaction Reports by Name \">Business Transaction Reports</a></td>"
[33] " theForm = document.aspnetForm;"
[34] "<tr>"
[35] "}"
[36] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl11_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl11$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[37] " <td class=\"style214\"><center><h2 class=\"menuclass\"><a href=\"http://ethics.ga.gov\">CFC Home Page</a></h2></center></td>"
[38] " </td>"
[39] "\t\t</tr><tr class=\"gridviewrow\" style=\"height:55px;\">"
[40] " <tr>"
[41] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl15_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">HOLCOMB</span>"
[42] " </table> "
[43] "function __doPostBack(eventTarget, eventArgument) {"
[44] " <tr>"
[45] " <td class=\"style218\"> </td>"
[46] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl10_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">MARTIN</span>"
[47] "\t\t</tr><tr class=\"gridviewrow\" style=\"height:55px;\">"
[48] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl17_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[49] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl08_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">BOZEMAN</span>"
[50] "" Reportsummary.aspx looks like something you might want.
example [1] ""
[2] ""
[3] "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">"
[4] "<html xmlns=\"http://www.w3.org/1999/xhtml\" >"
[5] "<head id=\"ctl00_Head1\"><script type=\"text/javascript\">window.NREUM||(NREUM={});NREUM.info = {\"beacon\":\"bam.nr-data.net\",\"errorBeacon\":\"bam.nr-data.net\",\"licenseKey\":\"41a18997af\",\"applicationID\":\"2112577\",\"transactionName\":\"ZVAHMkIHWRdWBRIMWlwaJDVgSVsLVQQfDEZGGgkJUgRODUQSOQJHXUAVFVUHRQdfFAMWQF5BFkhRFUcc\",\"queueTime\":0,\"applicationTime\":20,\"agent\":\"\",\"atts\":\"\"}</script><script type=\"text/javascript\">window.NREUM||(NREUM={}),__nr_require=function(e,t,n){function r(n){if(!t[n]){var o=t[n]={exports:{}};e[n][0].call(o.exports,function(t){var o=e[n][1][t];return r(o||t)},o,o.exports)}return t[n].exports}if(\"function\"==typeof __nr_require)return __nr_require;for(var o=0;o<n.length;o++)r(n[o]);return r}({1:[function(e,t,n){function r(){}function o(e,t,n){return function(){return i(e,[(new Date).getTime()].concat(u(arguments)),t?null:this,n),t?void 0:this}}var i=e(\"handle\"),a=e(2),u=e(3),c=e(\"ee\").get(\"tracer\"),f=NREUM;\"undefined\"==typeof window.newrelic&&(newrelic=f);var s=[\"setPageViewName\",\"setCustomAttribute\",\"setErrorHandler\",\"finished\",\"addToTrace\",\"inlineHit\"],l=\"api-\",p=l+\"ixn-\";a(s,function(e,t){f[t]=o(l+t,!0,\"api\")}),f.addPageAction=o(l+\"addPageAction\",!0),f.setCurrentRouteName=o(l+\"routeName\",!0),t.exports=newrelic,f.interaction=function(){return(new r).get()};var d=r.prototype={createTracer:function(e,t){var n={},r=this,o=\"function\"==typeof t;return i(p+\"tracer\",[Date.now(),e,n],r),function(){if(c.emit((o?\"\":\"no-\")+\"fn-start\",[Date.now(),r,o],n),o)try{return t.apply(this,arguments)}finally{c.emit(\"fn-end\",[Date.now()],n)}}}};a(\"setName,setAttribute,save,ignore,onEnd,getContext,end,get\".split(\",\"),function(e,t){d[t]=o(p+t)}),newrelic.noticeError=function(e){\"string\"==typeof e&&(e=new Error(e)),i(\"err\",[e,(new Date).getTime()])}},{}],2:[function(e,t,n){function r(e,t){var n=[],r=\"\",i=0;for(r in e)o.call(e,r)&&(n[i]=t(r,e[r]),i+=1);return n}var o=Object.prototype.hasOwnProperty;t.exports=r},{}],3:[function(e,t,n){function r(e,t,n){t||(t=0),\"undefined\"==typeof n&&(n=e?e.length:0);for(var r=-1,o=n-t||0,i=Array(o<0?0:o);++r<o;)i[r]=e[t+r];return i}t.exports=r},{}],ee:[function(e,t,n){function r(){}function o(e){function t(e){return e&&e instanceof r?e:e?c(e,u,i):i()}function n(n,r,o){if(!p.aborted){e&&e(n,r,o);for(var i=t(o),a=v(n),u=a.length,c=0;c<u;c++)a[c].apply(i,r);var f=s[w[n]];return f&&f.push([y,n,r,i]),i}}function d(e,t){b[e]=v(e).concat(t)}function v(e){return b[e]||[]}function g(e){return l[e]=l[e]||o(n)}function m(e,t){f(e,function(e,n){t=t||\"feature\",w[n]=t,t in s||(s[t]=[])})}var b={},w={},y={on:d,emit:n,get:g,listeners:v,context:t,buffer:m,abort:a,aborted:!1};return y}function i(){return new r}function a(){(s.api||s.feature)&&(p.aborted=!0,s=p.backlog={})}var u=\"nr@context\",c=e(\"gos\"),f=e(2),s={},l={},p=t.exports=o();p.backlog=s},{}],gos:[function(e,t,n){function r(e,t,n){if(o.call(e,t))return e[t];var r=n();if(Object.defineProperty&&Object.keys)try{return Object.defineProperty(e,t,{value:r,writable:!0,enumerable:!1}),r}catch(i){}return e[t]=r,r}var o=Object.prototype.hasOwnProperty;t.exports=r},{}],handle:[function(e,t,n){function r(e,t,n,r){o.buffer([e],r),o.emit(e,t,n)}var o=e(\"ee\").get(\"handle\");t.exports=r,r.ee=o},{}],id:[function(e,t,n){function r(e){var t=typeof e;return!e||\"object\"!==t&&\"function\"!==t?-1:e===window?0:a(e,i,function(){return o++})}var o=1,i=\"nr@id\",a=e(\"gos\");t.exports=r},{}],loader:[function(e,t,n){function r(){if(!h++){var e=y.info=NREUM.info,t=l.getElementsByTagName(\"script\")[0];if(setTimeout(f.abort,3e4),!(e&&e.licenseKey&&e.applicationID&&t))return f.abort();c(b,function(t,n){e[t]||(e[t]=n)}),u(\"mark\",[\"onload\",a()],null,\"api\");var n=l.createElement(\"script\");n.src=\"https://\"+e.agent,t.parentNode.insertBefore(n,t)}}function o(){\"complete\"===l.readyState&&i()}function i(){u(\"mark\",[\"domContent\",a()],null,\"api\")}function a(){return(new Date).getTime()}var u=e(\"handle\"),c=e(2),f=e(\"ee\"),s=window,l=s.document,p=\"addEventListener\",d=\"attachEvent\",v=s.XMLHttpRequest,g=v&&v.prototype;NREUM.o={ST:setTimeout,CT:clearTimeout,XHR:v,REQ:s.Request,EV:s.Event,PR:s.Promise,MO:s.MutationObserver},e(1);var m=\"\"+location,b={beacon:\"bam.nr-data.net\",errorBeacon:\"bam.nr-data.net\",agent:\"js-agent.newrelic.com/nr-998.min.js\"},w=v&&g&&g[p]&&!/CriOS/.test(navigator.userAgent),y=t.exports={offset:a(),origin:m,features:{},xhrWrappable:w};l[p]?(l[p](\"DOMContentLoaded\",i,!1),s[p](\"load\",r,!1)):(l[d](\"onreadystatechange\",o),s[d](\"onload\",r)),u(\"mark\",[\"firstbyte\",a()],null,\"api\");var h=0},{}]},{},[\"loader\"]);</script><title>"
[6] "\tLobbyist Reports Search | Georgia Government Transparency and Campaign Finance Commission of Georgia of Georgia"
[7] "</title><meta name=\"description\" content=\"Georgia Georgia Government Transparency and Campaign Finance Commission of Georgia. Find up-to-date information on the financing of political campaigns and lobbyist expenditures, contribution limits, and more.\" /><meta name=\"Keywords\" content=\"ethics, campaign, finance, contributions, expenditures, advisory opinions, lobby, financial statements, government, Georgia, elections\" /><meta name=\"rating\" content=\"general\" /><meta name=\"IS\" content=\"ok_trust\" /><meta name=\"distribution\" content=\"global\" /><meta name=\"copyright\" content=\"Georgia Government Transparency and Campaign Finance Commission of Georgia of Georgia\" /><meta name=\"alias\" content=\"http://www.ethics.ga.gov\" /><meta name=\"author\" content=\"Georgia Government Transparency and Campaign Finance Commission of Georgia\" /><meta name=\"owner\" content=\"Content: Georgia Government Transparency and Campaign Finance Commission of Georgia\" /><meta name=\"robots\" content=\"all\" /><meta name=\"revisit-after\" content=\"15 days\" />"
[8] "<script src=\"http://www.google-analytics.com/urchin.js\" type=\"text/javascript\"></script>"
[9] "<link href=\"../theethics.css\" rel=\"stylesheet\" />"
[10] " <script type=\"text/javascript\">"
[11] " _uacct = \"UA-2397276-1\";"
[12] " urchinTracker();"
[13] " function TABLE1_onclick() {"
[14] " }"
[15] "</script>"
[16] " <style type=\"text/css\">"
[17] ""
[18] "#dropmenudiv{"
[19] "position:absolute;"
[20] "border:1px solid black;"
[21] "border-bottom-width: 0;"
[22] "font:normal 12px Verdana;"
[23] "line-height:18px;"
[24] "z-index:100;"
[25] "}"
[26] ""
[27] "#dropmenudiv a{"
[28] "width: 100%;"
[29] "display: block;"
[30] "text-indent: 3px;"
[31] "border-bottom: 1px solid black;"
[32] "padding: 1px 0;"
[33] "text-decoration: none;"
[34] "font-weight: bold;"
[35] "}"
[36] ""
[37] "#dropmenudiv a:hover{ /*hover background color*/"
[38] "background-color: yellow;"
[39] "}"
[40] ""
[41] " </style>"
[42] ""
[43] "</head>"
[44] "<body>"
[45] "<form name=\"aspnetForm\" method=\"post\" action=\"Lobbyist_Groupsearchresults.aspx?Year=2006+and+Newer&GroupName=Aetna&GroupNameContains=\" id=\"aspnetForm\">"
[46] "<div>"
[47] "<input type=\"hidden\" name=\"__EVENTTARGET\" id=\"__EVENTTARGET\" value=\"\" />"
[48] "<input type=\"hidden\" name=\"__EVENTARGUMENT\" id=\"__EVENTARGUMENT\" value=\"\" />"
[49] "<input type=\"hidden\" name=\"__VIEWSTATE\" id=\"__VIEWSTATE\" value=\"wtpNxoDdPXrPdEz1G2jrnPfRXgTsGz3x5H6p/YCj6ljXFVFswwWcd/Om+/RRP04+EfnKDGU2hIKhYe+1Yx9Zw98wvVq6AgySwVmIWhOzeS5leUBu6vccbOhQzcOhm4pEdY4FIupv9IP8lNt/E5n48YXOBTnV0M1tjK2iZQmeKSXuAaTgKJ1XeBDRuq1RUMXSMdPIeZ7YzD69Bm5V/vzA9VJwFT/7v3B6va5FQAfXlFx/+m5aQqIIUyUqUPoYtu5YuVCcNGgyB3XVrScL+0j8kkCJqOPF/Whq05QmVo0TnJ3nK5I7wnK97SbLTj1klGJ6wuW4HTDfJF0kiNv9DdeksLjhU0HI6ndtJEWgeqMnqrlUCvjIlMyxHhL531Et0AgOfhAtDjMlzEYEDWDy+KuNHogJtzNTL3Ju8NevHJv3JqDebsb/OzWSGQk1Lf2H+r9gxLbfAqJGBEM5FDiPNNQUzsqAlhrKEY8KkfKR39/uy0cTqXo2rhqAJZubQb73PJTvSG7EesaeKhKKhF1QVgJI9JYdHiVAGgxtXW5DZFqlGl1sv6LT9TOp5GoIWnuPFj0oYOw5S0zwmHYdd6QDmxcaO4Krbaf65+F0NbPbwJZE8pYehRHcep9R/z9bWkK8OGxDzRgukBaDgdrpLHRTNlqIffSh7goun6PdBLjrEF5cRRXC5d9dDrgVoZ2dmkM6VopX0qROFfA9RNXAGAKjwkZ71r+gfYzN2l7yUJYM0Ix2DM9UZVVQagyXPjO0Ke20W4CRD5Psh0hHxWwT9sqlJek/Iw6mDSWxw4hU4tOSaUBk62kTCFZaxFp0XfhMCW4TRLRrbLsmJtPCy2B0rOZNd6B3iVivXsxB0PREVEJqnWxKf3XHv2eLAVuTVOwrmD9gOkzGBPcPUS8I8ntPk2DqWqkdZK2avIMxjxUyPgQ0uzx/YMw6i0+qD31bAZo4m4dheXaQ6vteiBxLlVBOy+5LDsG1hgot4yubntbWk6Qn8WJfXtYPKi1eYRefLiofKxGiZmW+Djscj+loEs8usTeVA7WSz4JD4D34VAXwSzEEq5892Dl6iQhV58afcMUBW5VyX+U8d0AWYBk7x1Bl/rALlA8HXDxbOcKxo9JkHHJI9LfxCEWU8RN8E4wQ+eUcDPimd/FvddoV9oWvN2AQwYpOVzdJbKcWh+6n/j7/9Sx6cn/zQAzLyxMHYRfap3MieB25i9yb94iIoJ8awvqU5jMz6Xbnpp5M64WeolSo2SVkt2wf9+D3Co7x/bxz+0uFFnK2f7KkJ/CIuune6DHt+PIp7Tnp1L4ww4wq8o58QCZHOWARu/9dl6JRekueIws788EH8PvcAtwbsxCn5AY73YMB7V5IcYEbbxzzv4OJdiDHpINgjZVmBj6HL4Wd3qaY+nFWI9bRA5Rspi5muq1rHBi30tW+DwGFig0KaGFfcVMjWvYgiMFmNzM7ppV4b5uab3XWcP8WpYCwKmXRxlf0tgmTT3UIyFfpglBMD/ohAQUFLNwbubugOzSziS5en71iLzfMB5tmTv+skoExAY0hmQDnjAQZtG4XlJ4pu22HsCV1jA3auN2ZRKv+xtw5hxUehYYBhB7439ObIxd19Tg13dPqxxyYqnZ7ItxgtCFEXMULjt3DiAhFIw02JBJOL2IUQ4ZaX0zzJlT25HL5vWmEuplMEGnb4poHwqE/It6eWZdYFjvhuquHL3L1VDAS1KjLkimLFBVDNK59ZxsIzQ9/NH5A6LfmBw6nyqtgbc5NbP2a7JOuHQEjZhYkiuvURnvRbeJStOvRMMMgbTfvakssrSArAimhK2m+mmxtzAWgGKcXND+Oi+TA9q0xB+uuFF30lvJOTCMv1goQBvAMtZk9PVx/IpM8QX/jJ4TQRnY0pwZGWrob6O3CUkyQ41vos0U0+8Qmxw2y+nONjB2pt2loga5byIzTLcx8YoY0ERAN3nLa284hWzjhAwZtZtMUp00+g6BFCjSJWvyujgo+Fz3DIgTsxf5isA7VrsvDdHD1koT2/3ZWbCsoA7dqfH5CJRwmmqbREWwQgA8239Fwemi3cJVEvGv599PA0Tmdp94a5DWz+VKJc7QJaNDk2mYjvLmqHCVX0IJbqLmYQgHotLFFCLcgDTO18Lifi8Ga/Ao2+OQZ5d4EUK1nNz+zUbu3drPp9zd823dLz3q++r/7WmnJxvSjPDQJ6gX4C5XZuF1xTRm3YF4lyUh/HvyBIxRKUd1onJ567dul0Wfmoiypsc1GtDGhJW3dF8tSx8UguGQvXXKIV8oZfy3sY8KY5tmXC/zt9L+Uo3nDCpBH8fl2n8ggTulNacM1Zi7B/UzbDbtYjmm0xBPvwry+0478L5ajnAMKSGrQUAaJn1etG5adWpX7NkWza8/Vc1rKYMXGVFcbl8NcjqQdQJxjw8Z9dcybWQUcJVGF/ZruP1B28dtG8COzn7wv+ctCK071kiIXUfgS67144RaCGM6lbko+lm0ZLubKkdaAYZJ4PpblTMjnyCZxn9e2dkHPhkZz2QugIS7jK1C6KTJXOhd1VCFROEOKA8byBdOOAFkVdCtiV20r8y4gQimCovyGpAQikNR+H1HFntQg0mm/Q0FtbME3yCSVyE+5yHMm/rlBRQAPEFsqVclypTt49KGirj7xneihtZoXbz2vJ57c5KW5Foqdyot8QTo7ohHpqMcnjph2+MpPDdcGa7AsPzcqoLt6LhIvdth+ANAO6vq+sttOioOYzurhvJPL8M+2zmzkDyE2C43xwvQ4PJ2xbf8+NAssGRZ+Mf87fyDKGHOlsf9vZngUwQeP6ZypU0jqhS92LmVdAiZ17wwWufe2dGPrpMhVfnjXr60HsdZ+l4HJ2PX3hkg9CtFkyz/EFMD89YJfZBdKTbo4ZqYm+zlvseNkLvYMOtv8xvyrBYj0g/4fKySz0maHvhvgVrG/f2uPn277zGGvveluFmCCIMdxuOlzSQnDlGhUBtkR0tEWT0HUjUYssrCFKFi4y4jo/BixWMttihMoXBBGFrGKLFFN3t5J3Bcqby0truxh4UnFV8ko3K7aInT7qDYX71JB77yENXVE2Mlhw7OcA2tlcAqAb/2//LPPSE0bMPWWfPXCW1a9kimtco78My695cvOoyKkMcqHuhHN+zbkoKuAF/qu4tTs7ku1V4IvaECd/XhLGjxzb+eaXJJdP6SpbcYWxRlwczNX0x+A7tuk4fiOw01m03Yb0QYZTxD+kev4Rwi+/RHS4+JnWRqYshreb5cYiEepfO45yp1w0HkB5cvk1Fra5P7fVoMRSnio1JZ19Zz9TEz5e0e7BbyG4NSLl08FpCX/PwaX5MCLF4gxj070H3ihcqtjj4cs0Eb29tFF4CHMtwpD7yu8ge/+mcJ3jkxvOtCMise9fVpingPbDjB11bbNUpX+TqBINd6x5ABua83603R3jcVOOo7Xhp9JKQc9s9WEk8ax22ADUu8SM2kdMP0xhQWXug9eWl9Yxe12BRkdmGzYkY5MOJ/edLqndIXLJ26UDsCQrc8H6WU9SI/4CAE3ehP1UHOTMQtkbTh0N/EFk9IogMCUdXfQLZrZ/5e5z5F6ZlfiCgC0e02gztCVoAuneNTWSMB3RcwcSgRULTAgca3tz52mZLsmkLwMlMvAduTCP7ZKdDH9cxqf/OLOCF9FdYnng4a2eaTlex4sj6QbEdW+gEpWdyU51z96VnWevnw/KUmRQGd0wclUaRBVLRUNkL2nrcrnsfc6LVxoeBWt3IzNZbDjiXTVE5mBwqqTRVF8ZsLqG48PY284aLQ33tDYhVCOyEifejg6aHFTHy2kDray3PpeFB+l4vNrWuG2tfVgzB0jsGR7fFVRbi6VRtvfNiDxF9EzJGPfGWC9fgACyUG78skaRbxUaLXlsWbsP9BlI0CmTippMYUFp34HCrH08IXcYfL13y78IBS/n/MItVNkJ3ZZzPu+qsUPSVZqQJujNDrC3NrdJuV2rvSKn3efMjAOGKcp3B2DInve+ZN6DGehsYFIsZuK864wYVx4DPLN2YJDMT8Li4QFH5pI+tSbx7r+kyJjDAohpqjHXEW6lGvJEnDdX/PIPUrF/529j0bgow/PxSoIfN5bGvFOfv+hZzA/miMWUp4ajbOgtYuTSLQ17hGsfUqN8EWGP+Ov7kJy1+Ch/MOq7N5jmlRCTuWCIshTOE36h1TsQCXT7IiP/C5vwimH5S1CsC6GvroEqv1o7pjcLfzj6GkyXVczgu91PbdK2l1XFaEsMMn6TxGO5KzOKTxT30w9QWMl7cD7X1nxDyD7gx2TN7KK8foinYIEdLV2U1WqeEfGQ1umstiHbwj6OCfMbW4tWx3opA82Pna77AoncqpfmTwxkAbzbcJTkSoviaY8F94ycAs//ItNgMoRpus4OQKRxEp3C+kwMnH7xSdn6qyBziQRmkvG/2bLSp3QRPpovn+66F+9Qq5ISU5Zf/sP5CYbL86BgdO7Vp/nOA+HqSXBLePGDaML+AlxPkgHUOPrHzhPooWfsCUWmO0HEKYBEo6+X5bhVspnY83BDknLvD1nxt6V8fA7hplYNvxnbHX3qF8=\" />"
[50] "</div>"
[51] ""
[52] "<script type=\"text/javascript\">"
[53] "//<![CDATA["
[54] "var theForm = document.forms['aspnetForm'];"
[55] "if (!theForm) {"
[56] " theForm = document.aspnetForm;"
[57] "}"
[58] "function __doPostBack(eventTarget, eventArgument) {"
[59] " if (!theForm.onsubmit || (theForm.onsubmit() != false)) {"
[60] " theForm.__EVENTTARGET.value = eventTarget;"
[61] " theForm.__EVENTARGUMENT.value = eventArgument;"
[62] " theForm.submit();"
[63] " }"
[64] "}"
[65] "//]]>"
[66] "</script>"
[67] ""
[68] ""
[69] "<div>"
[70] ""
[71] "\t<input type=\"hidden\" name=\"__VIEWSTATEGENERATOR\" id=\"__VIEWSTATEGENERATOR\" value=\"D60436F0\" />"
[72] "\t<input type=\"hidden\" name=\"__VIEWSTATEENCRYPTED\" id=\"__VIEWSTATEENCRYPTED\" value=\"\" />"
[73] "\t<input type=\"hidden\" name=\"__EVENTVALIDATION\" id=\"__EVENTVALIDATION\" value=\"88FmT4yh8srwW45kLF+mlbbRGHBkF/GUlFYvcu/FGvazo4350urk35PhWzUvhQXDBV6ZS7M+CZEkz3BnPw24tHH3gnaTqDvEuD+NlG2VLCDUis+zHqIPqoH5gyZjcTlVCpMckSpGlgV0WOp8Yn9CxnZUIUgCOytb+Nud4VlvfwAxyCbB5Se91N4bEa6VXWl4KrN9L6jAjQLhpqPiGKvHyH8tsO/wlQZayDJqo56c5DmbBjQ9aeGH23sd+SLa/Jc6e7zi74/loosXZOETZAOnTCxGya0=\" />"
[74] "</div>"
[75] "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\">"
[76] "<tr>"
[77] "<td width=\"700\"><table border=\"0\" cellpadding=\"0\">"
[78] " <tr>"
[79] " <td class=\"style217\">"
[80] "<a href=\"http://ethics.ga.gov\"><img src=\"../images/newtop.jpg\" width=\"992\" height=\"153\" style=\"border:0px;\" /></a>"
[81] " "
[82] " </td>"
[83] " </tr>"
[84] " "
[85] "</table>"
[86] " </div></td>"
[87] "</tr>"
[88] "<tr>"
[89] "<td class=\"style15\">"
[90] " <table height=\"394\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" "
[91] " frame=\"above\" style=\"width: 992px\">"
[92] "<tr>"
[93] "<td width=\"210\" class=\"tablestuff\">"
[94] " <br />"
[95] " <table>"
[96] ""
[97] " <!-- END COMMISSION MEETINGS--> "
[98] " <!-- SEC TRAINING-->"
[99] ""
[100] " "
[101] " <!-- END SEC TRAINING-->"
[102] " <!-- Quick Links-->"
[103] " <tr>"
[104] " <td class=\"style220\"> </td>"
[105] " <td>"
[106] " <table border=\"0\" style=\"width: 198px\">"
[107] " <tr>"
[108] " <td class=\"style218\"> </td>"
[109] " <td class=\"style219\">Search Lobbyist </td>"
[110] " </tr>"
[111] " "
[112] " <tr>"
[113] " <td class=\"style218\"> </td>"
[114] " <td class=\"quicklinks\"><a href=\"/search/Lobbyist/Lobbyist_ByName.aspx\" rel=\"nofollow\" title=\"Search by Name \">By Name</a></td>"
[115] " </tr>"
[116] " "
[117] " <tr>"
[118] " <td class=\"style218\"> </td>"
[119] " <td class=\"quicklinks\"><a href=\"/search/Lobbyist/Lobbyist_ByGroup.aspx\" rel=\"nofollow\" title=\"Search by Group \">By Group</a></td>"
[120] " </tr>"
[121] " "
[122] " <tr>"
[123] " <td class=\"style218\"> </td>"
[124] " <td class=\"quicklinks\"><a href=\"/search/Lobbyist/Lobbyist_ByExpenditures.aspx\" rel=\"nofollow\" title=\"Search by Expenditures \">By Expenditures</a></td>"
[125] " </tr>"
[126] " "
[127] " <tr>"
[128] " <td class=\"style218\"> </td>"
[129] " <td class=\"quicklinks\"><a href=\"/search/Lobbyist/Lobbyist_Menu.aspx\" rel=\"nofollow\" title=\"View Lobbyist Roster \">Lobbyist Roster</a></td>"
[130] " </tr>"
[131] " "
[132] " <tr>"
[133] " <td class=\"style218\"> </td>"
[134] " <td class=\"style212\"> </td>"
[135] " </tr>"
[136] " <tr>"
[137] " <td class=\"style218\"> </td>"
[138] " <td class=\"style219\">Search Other Report</td>"
[139] " </tr>"
[140] " "
[141] " <tr>"
[142] " <td class=\"style218\"> </td>"
[143] " <td class=\"quicklinks\"><a href=\"/search/Business/Business_Transaction_Search.aspx\" rel=\"nofollow\" title=\"Search Business Transaction Reports by Name \">Business Transaction Reports</a></td>"
[144] " </tr>"
[145] " "
[146] " <tr>"
[147] " <td class=\"style218\"> </td>"
[148] " <td class=\"quicklinks\"><a href=\"/search/Campaign/Campaign_ByName.aspx\" rel=\"nofollow\" title=\"Search Camapign Reports by Name \">Campaign Reports</a></td>"
[149] " </tr>"
[150] " "
[151] " <tr>"
[152] " <td class=\"style218\"> </td>"
[153] " <td class=\"quicklinks\"><a href=\"/search/Financial/Financial_ByName.aspx\" rel=\"nofollow\" title=\"Search Personal Financial Reports \">Personal Financial Reports & Affidavits</a></td>"
[154] " </tr>"
[155] " "
[156] " <tr>"
[157] " <td class=\"style218\"> </td>"
[158] " <td class=\"quicklinks\"><a href=\"/search/Lobbyist/Lobbyist_ByName.aspx\" rel=\"nofollow\" title=\"Search Lobbyist Reports \">Lobbyist Reports</a></td>"
[159] " </tr>"
[160] " "
[161] " <tr>"
[162] " <td class=\"style218\"> </td>"
[163] " <td class=\"quicklinks\"><a href=\"/search/Late/Late_ByName.aspx\" rel=\"nofollow\" title=\"Search Late/NON-Filer Reports \">Late/Non-Filer Reports</a></td>"
[164] " </tr>"
[165] " "
[166] " <tr>"
[167] " <td class=\"style218\"> </td>"
[168] " <td class=\"quicklinks\"><a href=\"/search/VendorGifts/VG_NameSearch.aspx\" rel=\"nofollow\" title=\"Search Vendor Gifts Reports\">Vendor Gifts Reports</a></td>"
[169] " </tr>"
[170] " "
[171] " <tr>"
[172] " <td class=\"style218\"> </td>"
[173] " <td class=\"quicklinks\"><a href=\"/search/ReportSummary.aspx\">CFC Main Search</a></td>"
[174] " </tr>"
[175] " <tr>"
[176] " <td class=\"style218\"> </td>"
[177] " <td class=\"style214\"><center><h2 class=\"menuclass\"><a href=\"http://ethics.ga.gov\">CFC Home Page</a></h2></center></td>"
[178] " </tr>"
[179] " </table>"
[180] " <br />"
[181] " </td> "
[182] " </tr>"
[183] " </table> "
[184] " </td> "
[185] " <td width=\"782\" style=\"background-color:white\" valign=\"top\">"
[186] " "
[187] " <h4 style=\"margin-left:145px; margin-top:75px;\"><span id=\"ctl00_ContentPlaceHolder1_lblMessage\" style=\"display:inline-block;width:100%;\">LOBBYIST SEARCH - BY GROUP RESULTS FOR 2006 AND NEWER</span></h4> "
[188] " <div style=\"text-align:center; margin-left:30px; width:95%\"><br />"
[189] "\t\t "
[190] " <table style=\"text-align:center; width:100%; margin: 0px 0px 0px 40px\">"
[191] " <tr><td style=\"text-align:center; margin-left:50px; width:90%\">"
[192] " <div>"
[193] ""
[194] "</div>"
[195] " </td>"
[196] " </tr>"
[197] " </table> "
[198] " "
[199] " <table style=\"text-align:center; margin: 0 auto; width:100%\">"
[200] " <tr><td style=\"text-align:center; margin: 0 auto; width:90%\"> "
[201] " <div>"
[202] "\t<table cellspacing=\"0\" cellpadding=\"4\" rules=\"all\" border=\"1\" id=\"ctl00_ContentPlaceHolder1_Results2\" style=\"color:#333333;width:99%;border-collapse:collapse;position: static;\">"
[203] "\t\t<tr class=\"gridviewheader\">"
[204] "\t\t\t<th align=\"left\" valign=\"middle\" scope=\"col\">Action</th><th align=\"left\" valign=\"middle\" scope=\"col\">Group</th><th align=\"left\" valign=\"middle\" scope=\"col\">Address</th><th align=\"left\" valign=\"middle\" scope=\"col\">Lobbyist</th>"
[205] "\t\t</tr><tr class=\"gridviewrow\" style=\"height:55px;\">"
[206] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[207] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl02_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl02$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[208] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">1100 ABERNATHY ROAD</span><span><br /></span><span class=\"lblentry\">SUITE 375</span><span><br /></span><span class=\"lblentry\">ATLANTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30328</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[209] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl02_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">NORTON</span>"
[210] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl02_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[211] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl02_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">LAURA</span>"
[212] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl02_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">LINDSEY</span>"
[213] " </td>"
[214] "\t\t</tr><tr class=\"gridviewalterrow\" style=\"height:55px;\">"
[215] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[216] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl03_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl03$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[217] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">5064 FIELDS POND CAVE</span><span><br /></span><span class=\"lblentry\">MARIETTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30068</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[218] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl03_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">SMITH</span>"
[219] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl03_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[220] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl03_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">DEFORD</span>"
[221] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl03_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[222] " </td>"
[223] "\t\t</tr><tr class=\"gridviewrow\" style=\"height:55px;\">"
[224] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[225] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl04_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl04$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[226] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">11675 GREAT OAKS WAY</span><span><br /></span><span class=\"lblentry\">ALPHARETTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30022</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[227] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl04_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ALBERT</span>"
[228] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl04_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[229] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl04_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">JOSHUA</span>"
[230] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl04_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[231] " </td>"
[232] "\t\t</tr><tr class=\"gridviewalterrow\" style=\"height:55px;\">"
[233] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[234] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl05_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl05$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[235] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">151 FARMINGTON AVENUE, MAIL STOP RC61</span><span><br /></span><span class=\"lblentry\">HARTFORD</span><span class=\"lblentry\">,</span><span class=\"lblentry\">CT</span><span class=\"lblentry\"> </span><span class=\"lblentry\">06156</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[236] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl05_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">BOLIA</span>"
[237] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl05_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[238] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl05_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">DONALD</span>"
[239] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl05_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[240] " </td>"
[241] "\t\t</tr><tr class=\"gridviewrow\" style=\"height:55px;\">"
[242] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[243] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl06_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl06$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[244] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">11675 GREAT OAKS WAY</span><span><br /></span><span class=\"lblentry\">ALPHARETTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30022</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[245] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl06_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">DUCKWORTH</span>"
[246] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl06_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[247] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl06_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">MARCUS</span>"
[248] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl06_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ELLIOT</span>"
[249] " </td>"
[250] "\t\t</tr><tr class=\"gridviewalterrow\" style=\"height:55px;\">"
[251] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[252] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl07_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl07$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[253] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">151 FARMINGTON AVENUE</span><span><br /></span><span class=\"lblentry\">HARTFORD</span><span class=\"lblentry\">,</span><span class=\"lblentry\">CT</span><span class=\"lblentry\"> </span><span class=\"lblentry\">06156</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[254] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl07_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">HAYES</span>"
[255] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl07_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[256] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl07_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ALLAN</span>"
[257] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl07_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">J.</span>"
[258] " </td>"
[259] "\t\t</tr><tr class=\"gridviewrow\" style=\"height:55px;\">"
[260] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[261] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl08_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl08$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[262] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA LIFE INSURANCE COMPANY</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">930 HARVEST DRIVE</span><span><br /></span><span class=\"lblentry\">SUITE U32N</span><span><br /></span><span class=\"lblentry\">BLUE BELL </span><span class=\"lblentry\">,</span><span class=\"lblentry\">PA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">19422</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[263] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl08_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">BOZEMAN</span>"
[264] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl08_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[265] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl08_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">JOHN</span>"
[266] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl08_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[267] " </td>"
[268] "\t\t</tr><tr class=\"gridviewalterrow\" style=\"height:55px;\">"
[269] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[270] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl09_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl09$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[271] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA LIFE INSURANCE COMPANY</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">930 HARVEST DRIVE</span><span><br /></span><span class=\"lblentry\">SUITE U32N</span><span><br /></span><span class=\"lblentry\">BLUE BELL </span><span class=\"lblentry\">,</span><span class=\"lblentry\">PA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">19422</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[272] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl09_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">EDGE</span>"
[273] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl09_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[274] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl09_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ARTHUR</span>"
[275] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl09_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">\"SKIN\"</span>"
[276] " </td>"
[277] "\t\t</tr><tr class=\"gridviewrow\" style=\"height:55px;\">"
[278] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[279] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl10_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl10$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[280] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA LIFE INSURANCE COMPANY</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">930 HARVEST DRIVE</span><span><br /></span><span class=\"lblentry\">SUITE U32N</span><span><br /></span><span class=\"lblentry\">BLUE BELL </span><span class=\"lblentry\">,</span><span class=\"lblentry\">PA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">19422</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[281] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl10_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">MARTIN</span>"
[282] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl10_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[283] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl10_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">JOHN</span>"
[284] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl10_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">\"TRIP\"</span>"
[285] " </td>"
[286] "\t\t</tr><tr class=\"gridviewalterrow\" style=\"height:55px;\">"
[287] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[288] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl11_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl11$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[289] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA LIFE INSURANCE COMPANY</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">930 HARVEST DRIVE</span><span><br /></span><span class=\"lblentry\">SUITE U32N</span><span><br /></span><span class=\"lblentry\">BLUE BELL </span><span class=\"lblentry\">,</span><span class=\"lblentry\">PA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">19422</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[290] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl11_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">PETTIT</span>"
[291] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl11_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[292] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl11_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">BOYD</span>"
[293] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl11_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[294] " </td>"
[295] "\t\t</tr><tr class=\"gridviewrow\" style=\"height:55px;\">"
[296] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[297] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl12_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl12$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[298] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA, INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">11675 THOUSAND OAKS WAY</span><span><br /></span><span class=\"lblentry\">ALPHARETTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30022</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[299] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl12_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ALEXANDER</span>"
[300] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl12_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[301] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl12_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">BRAD</span>"
[302] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl12_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">L.</span>"
[303] " </td>"
[304] "\t\t</tr><tr class=\"gridviewalterrow\" style=\"height:55px;\">"
[305] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[306] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl13_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl13$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[307] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA, INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">11675 THOUSAND OAKS WAY</span><span><br /></span><span class=\"lblentry\">ALPHARETTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30022</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[308] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl13_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">FORTSON</span>"
[309] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl13_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[310] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl13_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ROBERT</span>"
[311] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl13_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">L.</span>"
[312] " </td>"
[313] "\t\t</tr><tr class=\"gridviewrow\" style=\"height:55px;\">"
[314] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[315] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl14_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl14$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[316] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA, INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">11675 THOUSAND OAKS WAY</span><span><br /></span><span class=\"lblentry\">ALPHARETTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30022</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[317] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl14_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">GROOME</span>"
[318] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl14_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[319] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl14_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ASHLEY</span>"
[320] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl14_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">SHAREE</span>"
[321] " </td>"
[322] "\t\t</tr><tr class=\"gridviewalterrow\" style=\"height:55px;\">"
[323] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[324] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl15_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl15$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[325] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA, INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">11675 THOUSAND OAKS WAY</span><span><br /></span><span class=\"lblentry\">ALPHARETTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30022</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[326] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl15_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">HOLCOMB</span>"
[327] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl15_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[328] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl15_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">MISTY </span>"
[329] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl15_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">HARRIS</span>"
[330] " </td>"
[331] "\t\t</tr><tr class=\"gridviewrow\" style=\"height:55px;\">"
[332] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[333] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl16_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl16$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[334] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA, INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">11675 GREAKS OAKS WAY</span><span><br /></span><span class=\"lblentry\">ALPHARETTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30022</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[335] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl16_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">HUMBERSTONE</span>"
[336] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl16_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[337] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl16_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">SHEILA</span>"
[338] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl16_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[339] " </td>"
[340] "\t\t</tr><tr class=\"gridviewalterrow\" style=\"height:55px;\">"
[341] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[342] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl17_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl17$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[343] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA, INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">11675 GREAK OAKS WAY</span><span><br /></span><span class=\"lblentry\">ALPHARETTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30022</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[344] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl17_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">LONG</span>"
[345] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl17_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[346] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl17_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ANDREW</span>"
[347] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl17_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">RYAN</span>"
[348] " </td>"
[349] "\t\t</tr><tr class=\"gridviewrow\" style=\"height:55px;\">"
[350] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[351] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl18_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl18$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[352] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA, INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">11675 THOUSAND OAKS WAY</span><span><br /></span><span class=\"lblentry\">ALPHARETTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30022</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[353] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl18_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">LOOBY</span>"
[354] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl18_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[355] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl18_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">BRIAN</span>"
[356] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl18_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">W.</span>"
[357] " </td>"
[358] "\t\t</tr><tr class=\"gridviewalterrow\" style=\"height:55px;\">"
[359] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[360] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl19_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl19$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[361] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA, INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">11675 THOUSAND OAKS WAY</span><span><br /></span><span class=\"lblentry\">ALPHARETTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30022</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[362] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl19_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">PENNINGTON</span>"
[363] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl19_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[364] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl19_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">RUSSELL</span>"
[365] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl19_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[366] " </td>"
[367] "\t\t</tr><tr class=\"gridviewrow\" style=\"height:55px;\">"
[368] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[369] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl20_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl20$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[370] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA, INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">11675 GREAK OAKS WAY</span><span><br /></span><span class=\"lblentry\">ALPHARETTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30022</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[371] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl20_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ROBINSON</span>"
[372] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl20_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[373] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl20_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">PETE</span>"
[374] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl20_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[375] " </td>"
[376] "\t\t</tr><tr class=\"gridviewalterrow\" style=\"height:55px;\">"
[377] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[378] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl21_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl21$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[379] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA, INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">151 FARMINTON AVE</span><span><br /></span><span class=\"lblentry\">HARTFORD</span><span class=\"lblentry\">,</span><span class=\"lblentry\">CT</span><span class=\"lblentry\"> </span><span class=\"lblentry\">06156</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[380] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl21_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">TINER</span>"
[381] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl21_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[382] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl21_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">BROOKE</span>"
[383] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl21_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">FLAHERTY</span>"
[384] " </td>"
[385] "\t\t</tr><tr class=\"gridviewrow\" style=\"height:55px;\">"
[386] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[387] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl22_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl22$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[388] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA, INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">11675 THOUSAND OAKS WY</span><span><br /></span><span class=\"lblentry\">ALPHARETTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30022</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[389] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl22_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">TURNER</span>"
[390] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl22_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[391] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl22_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">JUDSON</span>"
[392] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl22_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">H.</span>"
[393] " </td>"
[394] "\t\t</tr><tr class=\"gridviewalterrow\" style=\"height:55px;\">"
[395] "\t\t\t<td align=\"left\" valign=\"middle\" style=\"width:10%;\">"
[396] " <a id=\"ctl00_ContentPlaceHolder1_Results2_ctl23_lnkView\" class=\"lblentrylink\" href=\"javascript:__doPostBack('ctl00$ContentPlaceHolder1$Results2$ctl23$lnkView','')\" style=\"display:inline-block;width:10%;\">View Group</a>"
[397] " </td><td class=\"highlightcolor\" align=\"left\" valign=\"middle\" style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA, INC.</td><td align=\"left\" valign=\"middle\" style=\"width:35%;\"><span class=\"lblentry\">11675 GREAK OAKS WAY</span><span><br /></span><span class=\"lblentry\">ALPHARETTA</span><span class=\"lblentry\">,</span><span class=\"lblentry\">GA</span><span class=\"lblentry\"> </span><span class=\"lblentry\">30022</span></td><td align=\"left\" valign=\"middle\" style=\"width:25%;\">"
[398] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl23_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">WILLIS</span>"
[399] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl23_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[400] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl23_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ROBB</span>"
[401] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl23_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[402] " </td>"
[403] "\t\t</tr>"
[404] "\t</table>"
[405] "</div>"
[406] " </td></tr></table>"
[407] " "
[408] " <br />"
[409] " <table style=\"text-align:center; margin: 0 auto; width:100%\">"
[410] " <tr> "
[411] " <td style=\"text-align:center; width:100%\">"
[412] " <input type=\"submit\" name=\"ctl00$ContentPlaceHolder1$btnSearch\" value=\"New Search\" id=\"ctl00_ContentPlaceHolder1_btnSearch\" class=\"submit\" style=\"background-color:#CCCCCC;font-weight:bold;width:150px;\" /></td> "
[413] " </tr>"
[414] " </table><br />"
[415] ""
[416] " </div>"
[417] ""
[418] " </td> "
[419] " </tr>"
[420] " <!-- FOOTER -->"
[421] " </table>"
[422] "<!-- END FOOTER --> "
[423] "<!-- FOOTER LINKS --> "
[424] "</form>"
[425] "<!-- FOOTER LINKS --> "
[426] "</body>"
[427] "<script type=\"text/javascript\">"
[428] " _uacct=\"UA-2397276-1\";"
[429] " urchinTracker();"
[430] "function TABLE1_onclick() {"
[431] "}"
[432] "</script>"
[433] "<script type=\"text/javascript\">"
[434] ""
[435] " var _gaq = _gaq || [];"
[436] " _gaq.push(['_setAccount', 'UA-37326765-1']);"
[437] " _gaq.push(['_trackPageview']);"
[438] ""
[439] " (function() {"
[440] " var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;"
[441] " ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';"
[442] " var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);"
[443] " })();"
[444] ""
[445] "</script>"
[446] "<script type='text/javascript'>"
[447] "window.__lo_site_id = 51939;"
[448] ""
[449] " (function() {"
[450] " var wa = document.createElement('script'); wa.type = 'text/javascript'; wa.async = true;"
[451] " wa.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://cdn') + '.luckyorange.com/w.js';"
[452] " var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(wa, s);"
[453] " })();"
[454] " </script>"
[455] ""
[456] "</html>" Other files of interest: Lobbyist_ByName.aspx
Lines 389 - 392 have one name:
example[389:392]
[1] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl22_lblLName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">TURNER</span>"
[2] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl22_comma\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">, </span>"
[3] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl22_lblFName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">JUDSON</span>"
[4] " <span id=\"ctl00_ContentPlaceHolder1_Results2_ctl22_lblMName\" style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">H.</span>" ss<- scan("C:/git/galegis/Data/HTML/Lobbyist Search Results.html",
what="\n")Read 1920 itemsss[1:50] [1] "<!DOCTYPE"
[2] "html"
[3] "PUBLIC"
[4] "-//W3C//DTD XHTML 1.0 Transitional//EN"
[5] "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
[6] ">"
[7] "<html"
[8] "xmlns=\"http://www.w3.org/1999/xhtml\""
[9] ">"
[10] "<head"
[11] "id=\"ctl00_Head1\"><script"
[12] "type=\"text/javascript\">window.NREUM||(NREUM={});NREUM.info"
[13] "="
[14] "{\"beacon\":\"bam.nr-data.net\",\"errorBeacon\":\"bam.nr-data.net\",\"licenseKey\":\"41a18997af\",\"applicationID\":\"2112577\",\"transactionName\":\"ZVAHMkIHWRdWBRIMWlwaJDVgSVsLVQQfDEZGGgkJUgRODUQSOQJHXUAVFVUHRQdfFAMWQF5BFkhRFUcc\",\"queueTime\":0,\"applicationTime\":20,\"agent\":\"\",\"atts\":\"\"}</script><script"
[15] "type=\"text/javascript\">window.NREUM||(NREUM={}),__nr_require=function(e,t,n){function"
[16] "r(n){if(!t[n]){var"
[17] "o=t[n]={exports:{}};e[n][0].call(o.exports,function(t){var"
[18] "o=e[n][1][t];return"
[19] "r(o||t)},o,o.exports)}return"
[20] "t[n].exports}if(\"function\"==typeof"
[21] "__nr_require)return"
[22] "__nr_require;for(var"
[23] "o=0;o<n.length;o++)r(n[o]);return"
[24] "r}({1:[function(e,t,n){function"
[25] "r(){}function"
[26] "o(e,t,n){return"
[27] "function(){return"
[28] "i(e,[(new"
[29] "Date).getTime()].concat(u(arguments)),t?null:this,n),t?void"
[30] "0:this}}var"
[31] "i=e(\"handle\"),a=e(2),u=e(3),c=e(\"ee\").get(\"tracer\"),f=NREUM;\"undefined\"==typeof"
[32] "window.newrelic&&(newrelic=f);var"
[33] "s=[\"setPageViewName\",\"setCustomAttribute\",\"setErrorHandler\",\"finished\",\"addToTrace\",\"inlineHit\"],l=\"api-\",p=l+\"ixn-\";a(s,function(e,t){f[t]=o(l+t,!0,\"api\")}),f.addPageAction=o(l+\"addPageAction\",!0),f.setCurrentRouteName=o(l+\"routeName\",!0),t.exports=newrelic,f.interaction=function(){return(new"
[34] "r).get()};var"
[35] "d=r.prototype={createTracer:function(e,t){var"
[36] "n={},r=this,o=\"function\"==typeof"
[37] "t;return"
[38] "i(p+\"tracer\",[Date.now(),e,n],r),function(){if(c.emit((o?\"\":\"no-\")+\"fn-start\",[Date.now(),r,o],n),o)try{return"
[39] "t.apply(this,arguments)}finally{c.emit(\"fn-end\",[Date.now()],n)}}}};a(\"setName,setAttribute,save,ignore,onEnd,getContext,end,get\".split(\",\"),function(e,t){d[t]=o(p+t)}),newrelic.noticeError=function(e){\"string\"==typeof"
[40] "e&&(e=new"
[41] "Error(e)),i(\"err\",[e,(new"
[42] "Date).getTime()])}},{}],2:[function(e,t,n){function"
[43] "r(e,t){var"
[44] "n=[],r=\"\",i=0;for(r"
[45] "in"
[46] "e)o.call(e,r)&&(n[i]=t(r,e[r]),i+=1);return"
[47] "n}var"
[48] "o=Object.prototype.hasOwnProperty;t.exports=r},{}],3:[function(e,t,n){function"
[49] "r(e,t,n){t||(t=0),\"undefined\"==typeof"
[50] "n&&(n=e?e.length:0);for(var" Looks like scan is a little cleaner. Trying to quickly identify the lines containing names.
namelocator<- grep("bold;",ss)
namelines<- ss[namelocator]
namelines [1] "bold;"
[2] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA</td><td"
[3] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">NORTON</span>"
[4] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[5] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">LAURA</span>"
[6] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">LINDSEY</span>"
[7] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA</td><td"
[8] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">SMITH</span>"
[9] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[10] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">DEFORD</span>"
[11] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[12] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[13] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ALBERT</span>"
[14] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[15] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">JOSHUA</span>"
[16] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[17] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[18] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">BOLIA</span>"
[19] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[20] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">DONALD</span>"
[21] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[22] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[23] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">DUCKWORTH</span>"
[24] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[25] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">MARCUS</span>"
[26] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ELLIOT</span>"
[27] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[28] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">HAYES</span>"
[29] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[30] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ALLAN</span>"
[31] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">J.</span>"
[32] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[33] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">BOZEMAN</span>"
[34] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[35] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">JOHN</span>"
[36] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[37] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[38] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">EDGE</span>"
[39] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[40] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ARTHUR</span>"
[41] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">\"SKIN\"</span>"
[42] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[43] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">MARTIN</span>"
[44] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[45] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">JOHN</span>"
[46] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">\"TRIP\"</span>"
[47] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[48] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">PETTIT</span>"
[49] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[50] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">BOYD</span>"
[51] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[52] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[53] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ALEXANDER</span>"
[54] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[55] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">BRAD</span>"
[56] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">L.</span>"
[57] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[58] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">FORTSON</span>"
[59] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[60] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ROBERT</span>"
[61] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">L.</span>"
[62] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[63] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">GROOME</span>"
[64] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[65] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ASHLEY</span>"
[66] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">SHAREE</span>"
[67] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[68] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">HOLCOMB</span>"
[69] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[70] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">MISTY"
[71] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">HARRIS</span>"
[72] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[73] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">HUMBERSTONE</span>"
[74] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[75] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">SHEILA</span>"
[76] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[77] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[78] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">LONG</span>"
[79] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[80] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ANDREW</span>"
[81] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">RYAN</span>"
[82] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[83] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">LOOBY</span>"
[84] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[85] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">BRIAN</span>"
[86] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">W.</span>"
[87] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[88] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">PENNINGTON</span>"
[89] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[90] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">RUSSELL</span>"
[91] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[92] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[93] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ROBINSON</span>"
[94] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[95] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">PETE</span>"
[96] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[97] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[98] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">TINER</span>"
[99] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[100] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">BROOKE</span>"
[101] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">FLAHERTY</span>"
[102] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[103] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">TURNER</span>"
[104] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[105] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">JUDSON</span>"
[106] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">H.</span>"
[107] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[108] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">WILLIS</span>"
[109] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">,"
[110] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\">ROBB</span>"
[111] "style=\"font-family:Arial;font-size:X-Small;font-weight:bold;\"></span>"
[112] "style=\"background-color:#CCCCCC;font-weight:bold;width:150px;\"" Cleaning it up a bit more. Gsubbing blanks for the html styling.
nl<- gsub("font-family:Arial;font-size:X-Small;font-weight:bold;",
"",
namelines)
nl [1] "bold;"
[2] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA</td><td"
[3] "style=\"\">NORTON</span>"
[4] "style=\"\">,"
[5] "style=\"\">LAURA</span>"
[6] "style=\"\">LINDSEY</span>"
[7] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA</td><td"
[8] "style=\"\">SMITH</span>"
[9] "style=\"\">,"
[10] "style=\"\">DEFORD</span>"
[11] "style=\"\"></span>"
[12] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[13] "style=\"\">ALBERT</span>"
[14] "style=\"\">,"
[15] "style=\"\">JOSHUA</span>"
[16] "style=\"\"></span>"
[17] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[18] "style=\"\">BOLIA</span>"
[19] "style=\"\">,"
[20] "style=\"\">DONALD</span>"
[21] "style=\"\"></span>"
[22] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[23] "style=\"\">DUCKWORTH</span>"
[24] "style=\"\">,"
[25] "style=\"\">MARCUS</span>"
[26] "style=\"\">ELLIOT</span>"
[27] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[28] "style=\"\">HAYES</span>"
[29] "style=\"\">,"
[30] "style=\"\">ALLAN</span>"
[31] "style=\"\">J.</span>"
[32] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[33] "style=\"\">BOZEMAN</span>"
[34] "style=\"\">,"
[35] "style=\"\">JOHN</span>"
[36] "style=\"\"></span>"
[37] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[38] "style=\"\">EDGE</span>"
[39] "style=\"\">,"
[40] "style=\"\">ARTHUR</span>"
[41] "style=\"\">\"SKIN\"</span>"
[42] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[43] "style=\"\">MARTIN</span>"
[44] "style=\"\">,"
[45] "style=\"\">JOHN</span>"
[46] "style=\"\">\"TRIP\"</span>"
[47] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA"
[48] "style=\"\">PETTIT</span>"
[49] "style=\"\">,"
[50] "style=\"\">BOYD</span>"
[51] "style=\"\"></span>"
[52] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[53] "style=\"\">ALEXANDER</span>"
[54] "style=\"\">,"
[55] "style=\"\">BRAD</span>"
[56] "style=\"\">L.</span>"
[57] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[58] "style=\"\">FORTSON</span>"
[59] "style=\"\">,"
[60] "style=\"\">ROBERT</span>"
[61] "style=\"\">L.</span>"
[62] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[63] "style=\"\">GROOME</span>"
[64] "style=\"\">,"
[65] "style=\"\">ASHLEY</span>"
[66] "style=\"\">SHAREE</span>"
[67] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[68] "style=\"\">HOLCOMB</span>"
[69] "style=\"\">,"
[70] "style=\"\">MISTY"
[71] "style=\"\">HARRIS</span>"
[72] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[73] "style=\"\">HUMBERSTONE</span>"
[74] "style=\"\">,"
[75] "style=\"\">SHEILA</span>"
[76] "style=\"\"></span>"
[77] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[78] "style=\"\">LONG</span>"
[79] "style=\"\">,"
[80] "style=\"\">ANDREW</span>"
[81] "style=\"\">RYAN</span>"
[82] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[83] "style=\"\">LOOBY</span>"
[84] "style=\"\">,"
[85] "style=\"\">BRIAN</span>"
[86] "style=\"\">W.</span>"
[87] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[88] "style=\"\">PENNINGTON</span>"
[89] "style=\"\">,"
[90] "style=\"\">RUSSELL</span>"
[91] "style=\"\"></span>"
[92] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[93] "style=\"\">ROBINSON</span>"
[94] "style=\"\">,"
[95] "style=\"\">PETE</span>"
[96] "style=\"\"></span>"
[97] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[98] "style=\"\">TINER</span>"
[99] "style=\"\">,"
[100] "style=\"\">BROOKE</span>"
[101] "style=\"\">FLAHERTY</span>"
[102] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[103] "style=\"\">TURNER</span>"
[104] "style=\"\">,"
[105] "style=\"\">JUDSON</span>"
[106] "style=\"\">H.</span>"
[107] "style=\"font-size:Small;font-weight:bold;width:30%;\">AETNA,"
[108] "style=\"\">WILLIS</span>"
[109] "style=\"\">,"
[110] "style=\"\">ROBB</span>"
[111] "style=\"\"></span>"
[112] "style=\"background-color:#CCCCCC;font-weight:bold;width:150px;\"" nl7
[1] "bold;" "\"\"AETNA</td<td" "\"\"NORTON"
[4] "\"\"," "\"\"LAURA" "\"\"LINDSEY"
[7] "\"\"AETNA</td<td" "\"\"SMITH" "\"\","
[10] "\"\"DEFORD" "\"\"" "\"\"AETNA"
[13] "\"\"ALBERT" "\"\"," "\"\"JOSHUA"
[16] "\"\"" "\"\"AETNA" "\"\"BOLIA"
[19] "\"\"," "\"\"DONALD" "\"\""
[22] "\"\"AETNA" "\"\"DUCKWORTH" "\"\","
[25] "\"\"MARCUS" "\"\"ELLIOT" "\"\"AETNA"
[28] "\"\"HAYES" "\"\"," "\"\"ALLAN"
[31] "\"\"J." "\"\"AETNA" "\"\"BOZEMAN"
[34] "\"\"," "\"\"JOHN" "\"\""
[37] "\"\"AETNA" "\"\"EDGE" "\"\","
[40] "\"\"ARTHUR" "\"\"\"SKIN\"" "\"\"AETNA"
[43] "\"\"MARTIN" "\"\"," "\"\"JOHN"
[46] "\"\"\"TRIP\"" "\"\"AETNA" "\"\"PETTIT"
[49] "\"\"," "\"\"BOYD" "\"\""
[52] "\"\"AETNA," "\"\"ALEXANDER" "\"\","
[55] "\"\"BRAD" "\"\"L." "\"\"AETNA,"
[58] "\"\"FORTSON" "\"\"," "\"\"ROBERT"
[61] "\"\"L." "\"\"AETNA," "\"\"GROOME"
[64] "\"\"," "\"\"ASHLEY" "\"\"SHAREE"
[67] "\"\"AETNA," "\"\"HOLCOMB" "\"\","
[70] "\"\"MISTY" "\"\"HARRIS" "\"\"AETNA,"
[73] "\"\"HUMBERSTONE" "\"\"," "\"\"SHEILA"
[76] "\"\"" "\"\"AETNA," "\"\"LONG"
[79] "\"\"," "\"\"ANDREW" "\"\"RYAN"
[82] "\"\"AETNA," "\"\"LOOBY" "\"\","
[85] "\"\"BRIAN" "\"\"W." "\"\"AETNA,"
[88] "\"\"PENNINGTON" "\"\"," "\"\"RUSSELL"
[91] "\"\"" "\"\"AETNA," "\"\"ROBINSON"
[94] "\"\"," "\"\"PETE" "\"\""
[97] "\"\"AETNA," "\"\"TINER" "\"\","
[100] "\"\"BROOKE" "\"\"FLAHERTY" "\"\"AETNA,"
[103] "\"\"TURNER" "\"\"," "\"\"JUDSON"
[106] "\"\"H." "\"\"AETNA," "\"\"WILLIS"
[109] "\"\"," "\"\"ROBB" "\"\""
[112] "\"\"" So for Josh Edgeskin, that’s EDGE , ARTHUR “SKIN” on the webpage. I did lose the addresses by focusing on the names.
Attempting to pull down HTML.
si<- getURL("http://media.ethics.ga.gov/search/Lobbyist/Lobbyist_Groupsearchresults.aspx?&Year=2006%20and%20Newer&GroupName=&GroupNameContains=gas")
ssi<- scan(si,what="\n")cannot open file '
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="ctl00_Head1"><script type="text/javascript">window.NREUM||(NREUM={});NREUM.info = {"beacon":"bam.nr-data.net","errorBeacon":"bam.nr-data.net","licenseKey":"41a18997af","applicationID":"2106491","transactionName":"ZVAHMkIHWRdWBRIMWlwaJDVgSVsLVQQfDEZGGgkJUgRODUQSOQJHXUAVFVUHRQdfFAMWQF5BFkhRFUcc","queueTime":0,"applicationTime":90,"agent":"","atts":""}</script><script type="text/javascript">window.NREUM||(NREUM={}),__nr_require=function(e,t,n){function r(n){if(!t[n]){var o=t[n]={exports:{}};e[n][0].call(o.exports,function(t){var o=e[n][1][t];return r(o||t)},o,o.exports)}return t[n].exports}if("function"==typeof __nr_require)return __nr_require;for(var o=0;o<n.length;o++)r(n[o]);return r}({1:[function(e,t,n){function r(){}function o(e,t,n){return function(){return i(e,[(new Date).getTime()].c [... truncated]Error in file(file, "r") : cannot open the connectionNot successful.
From Stack:
library(XML)
tu<- "http://media.ethics.ga.gov/search/Lobbyist/Lobbyist_Groupsearchresults.aspx?&Year=2006%20and%20Newer&GroupName=&GroupNameContains=gas"
tab<- readHTMLTable(tu)Interesting…
str(tab)List of 9
$ NULL :'data.frame': 81 obs. of 4 variables:
..$ V1: Factor w/ 7 levels "","Â"," \r\n \r\n  \r\n Search Lobbyist \r\n  \r\n By Name\r\n  \r"| __truncated__,..: 1 4 3 2 2 2 2 2 2 2 ...
..$ V2: Factor w/ 33 levels "Â"," \r\n Search Lobbyist \r\n  \r\n By Name\r\n  \r\n By Group\r\n  \r\n "| __truncated__,..: NA NA 23 2 27 8 7 6 22 1 ...
..$ V3: Factor w/ 30 levels "10 PEACHTREE PLACE, NESUITE 1000ATLANTA,GA 30309",..: NA NA NA NA NA NA NA NA NA NA ...
..$ V4: Factor w/ 53 levels "ALEXANDER\r\n , \r\n BRAD\r\n L.",..: NA NA NA NA NA NA NA NA NA NA ...
$ NULL : NULL
$ NULL :'data.frame': 78 obs. of 4 variables:
..$ V1: Factor w/ 5 levels "","Â","Action",..: 2 2 2 2 2 2 2 2 2 2 ...
..$ V2: Factor w/ 32 levels "Â"," \r\n Search Lobbyist \r\n  \r\n By Name\r\n  \r\n By Group\r\n  \r\n "| __truncated__,..: 2 26 8 7 6 22 1 27 5 9 ...
..$ V3: Factor w/ 30 levels "10 PEACHTREE PLACE, NESUITE 1000ATLANTA,GA 30309",..: NA NA NA NA NA NA NA NA NA NA ...
..$ V4: Factor w/ 53 levels "ALEXANDER\r\n , \r\n BRAD\r\n L.",..: NA NA NA NA NA NA NA NA NA NA ...
$ NULL :'data.frame': 15 obs. of 2 variables:
..$ Â : Factor w/ 1 level "Â": 1 1 1 1 1 1 1 1 1 1 ...
..$ ÂÂ
Search Lobbyist
ÂÂ
By Name
ÂÂ
By Group
ÂÂ
By Expenditures
ÂÂ
Lobbyist Roster
ÂÂ
ÂÂ
ÂÂ
Search Other Report
ÂÂ
Business Transaction Reports
ÂÂ
Campaign Reports
ÂÂ
Personal Financial Reports & Affidavits
ÂÂ
Lobbyist Reports
ÂÂ
Late/Non-Filer Reports
ÂÂ
Vendor Gifts Reports
ÂÂ
CFC Main Search
ÂÂ
CFC Home Page: Factor w/ 15 levels "Â","Business Transaction Reports",..: 13 5 4 3 11 1 14 2 6 12 ...
$ NULL :'data.frame': 14 obs. of 2 variables:
..$ Â : Factor w/ 1 level "Â": 1 1 1 1 1 1 1 1 1 1 ...
..$ Search Lobbyist: Factor w/ 14 levels "Â","Business Transaction Reports",..: 5 4 3 11 1 13 2 6 12 10 ...
$ NULL : NULL
$ NULL :'data.frame': 60 obs. of 4 variables:
..$ V1: Factor w/ 3 levels "Action","ActionGroupAddressLobbyist\r\n\t\t\r\n View Group\r\n ATLANTA GAS LIGHT COMPANY"| __truncated__,..: 2 1 3 3 3 3 3 3 3 3 ...
..$ V2: Factor w/ 16 levels "ATLANTA GAS LIGHT COMPANY",..: NA 10 1 1 1 2 3 4 4 5 ...
..$ V3: Factor w/ 30 levels "10 PEACHTREE PLACE, NESUITE 1000ATLANTA,GA 30309",..: NA 25 3 1 3 13 29 27 27 26 ...
..$ V4: Factor w/ 53 levels "ALEXANDER\r\n , \r\n BRAD\r\n L.",..: NA 24 10 37 51 9 20 28 36 3 ...
$ ctl00_ContentPlaceHolder1_Results2:'data.frame': 58 obs. of 4 variables:
..$ Action : Factor w/ 1 level "View Group": 1 1 1 1 1 1 1 1 1 1 ...
..$ Group : Factor w/ 15 levels "ATLANTA GAS LIGHT COMPANY",..: 1 1 1 2 3 4 4 5 5 5 ...
..$ Address : Factor w/ 29 levels "10 PEACHTREE PLACE, NESUITE 1000ATLANTA,GA 30309",..: 3 1 3 13 28 26 26 25 15 15 ...
..$ Lobbyist: Factor w/ 52 levels "ALEXANDER\r\n , \r\n BRAD\r\n L.",..: 10 36 50 9 20 27 35 3 6 8 ...
$ NULL : NULLtry v4 or
xma$Lobbyist
[1] DAVIS \r\n , \r\n MICHAEL\r\n SHAWN
[2] PIERCE\r\n , \r\n SHANNON\r\n OMIA
[3] WEAVER\r\n , \r\n DAVID \r\n CHRISTOPHER
[4] DAVIDSON\r\n , \r\n PAMELA\r\n SUE
[5] HATCHER\r\n , \r\n KEITH\r\n E.
[6] MCCONNELL\r\n , \r\n JULIANNA
[7] PETTIT\r\n , \r\n VICKIE\r\n C.
[8] BAXTER\r\n , \r\n DAVID\r\n MARK
[9] CARDOZO\r\n , \r\n FREDDY\r\n S
[10] COAN\r\n , \r\n CHRISTOPHER\r\n FUREY
[11] DOTSON\r\n , \r\n DENISE\r\n AVIS
[12] GOODMAN\r\n , \r\n MARK\r\n E
[13] GREINER\r\n , \r\n KEVIN\r\n A
[14] HODGES\r\n , \r\n MEREDITH\r\n WALKER
[15] MULLIS\r\n , \r\n VANCE\r\n C
[16] WEATHERLY\r\n , \r\n PHILIP\r\n GREGORY
[17] FIVEASH\r\n , \r\n BRYAN\r\n LILES
[18] MCFADIN\r\n , \r\n PATRICIA
[19] MONROE\r\n , \r\n JOSEPH\r\n C.
[20] STANLEY\r\n , \r\n HAYDON
[21] STOKES\r\n , \r\n PETER\r\n A.
[22] ZACK\r\n , \r\n MARIA\r\n STROLLO
[23] FRALICK\r\n , \r\n LAUREN\r\n WILKES
[24] EDGE\r\n , \r\n ARTHUR\r\n "SKIN"
[25] MARTIN\r\n , \r\n JOHN\r\n "TRIP"
[26] PETTIT\r\n , \r\n BOYD
[27] BOZEMAN\r\n , \r\n JOHN
[28] ROBINSON\r\n , \r\n DENNING
[29] SCHMIEDT\r\n , \r\n ROBERT\r\n C.
[30] ZACK\r\n , \r\n MARIA\r\n STROLLO
[31] ALEXANDER\r\n , \r\n BRAD\r\n L.
[32] AUSTIN\r\n , \r\n J.\r\n CLINTON
[33] BENNECKE\r\n , \r\n PAUL\r\n NATHANIEL
[34] CHOATE\r\n , \r\n SAM
[35] DAVIS\r\n , \r\n ROBERT\r\n EDENS
[36] GALLOWAY\r\n , \r\n NEWTON\r\n MONROE
[37] HORLACHER\r\n , \r\n GARY\r\n G.
[38] LONG\r\n , \r\n ANDREW\r\n RYAN
[39] LYNDALL\r\n , \r\n TERRI\r\n M.
[40] MCPHAIL\r\n , \r\n AMANDA\r\n R.
[41] MOORE\r\n , \r\n BO
[42] SHELNUTT\r\n , \r\n MICHAEL
[43] SIMON\r\n , \r\n PHILIP\r\n ANTHONY
[44] TALMADGE\r\n , \r\n WILLIAM\r\n MURPHY
[45] BOZEMAN\r\n , \r\n JOHN
[46] EDGE\r\n , \r\n ARTHUR\r\n "SKIN"
[47] FRALICK\r\n , \r\n LAUREN\r\n WILKES
[48] MARTIN\r\n , \r\n JOHN\r\n "TRIP"
[49] MORGAN\r\n , \r\n JAY
[50] SIMPSON\r\n , \r\n MARISA
[51] TOWNS\r\n , \r\n HUNTER\r\n EDWARD
[52] WOMACK\r\n , \r\n CAROLINE\r\n HOLLEY
[53] FORRY\r\n , \r\n BOB
[54] ROBINSON\r\n , \r\n PETE
[55] PETTIT\r\n , \r\n BOYD
[56] ROBINSON \r\n , \r\n ROY\r\n BRYANT
[57] HUNT \r\n , \r\n WENDELL \r\n BRYCE
[58] ROWAN\r\n , \r\n ROBERT\r\n A.
52 Levels: ALEXANDER\r\n , \r\n BRAD\r\n L. ...For the lobbyist names, a little white space handing and we’re good.
ANALYSIS OUTCOME Looks like the XML package with the readHTMLtable command is going to be the way to go for scraping the URLs.
The queries look pretty simple. Trying this page. Searched for last name Johnson, other fields blank.
query_result<-"http://media.ethics.ga.gov/search/Financial/Financial_BYNameResults.aspx?LastName=Johnson&FirstName=&City=&FilerID=&OfficeStatus=0&OfficeName=&District=&Post=&Circuit=&Division=&Type=Name"
#So, we should be able to construct a URL like this one based on various name searches, then feed that to the readHTMLtable function. ConstructFinancialQuery<-
function(lastname=NULL, firstname=NULL, city=NULL) {
library(XML)
full_url<- paste("http://media.ethics.ga.gov/search/Financial/Financial_BYNameResults.aspx?LastName=",lastname,"&FirstName=",firstname,"&City=",city,"&FilerID=&OfficeStatus=0&OfficeName=&District=&Post=&Circuit=&Division=&Type=Name",sep="")
full_url
html_result<- readHTMLTable(full_url)
html_result}
#xk<- data.frame(query=full_url,result=html_result)
#xk
#DIAGNOSING - RETURN THE QUERYThe ConstructFinancialQuery function should take lastname fn and city as arguments, construct the query , and return the query and the html result.
cfq<- ConstructFinancialQuery("Johnson","Lisa","Atlanta")
Error in (function (..., row.names = NULL, check.rows = FALSE, check.names = TRUE, :
arguments imply differing number of rows: 19, 0, 16, 14, 13Run successful, checking output.
str(cfq)List of 6
$ NULL:'data.frame': 19 obs. of 2 variables:
..$ V1: Factor w/ 5 levels "","Â"," \r\n \r\n  \r\n    Search Financial\r\n  \r\n By Name\r\n "| __truncated__,..: 1 4 3 2 2 2 2 2 2 2 ...
..$ V2: Factor w/ 16 levels "Â"," \r\n    Search Financial\r\n  \r\n By Name\r\n  \r\n By Office\r\n  \r"| __truncated__,..: NA NA 12 2 4 6 7 11 1 3 ...
$ NULL: NULL
$ NULL:'data.frame': 16 obs. of 2 variables:
..$ ÂÂ
ÂÂ
   Search Financial
ÂÂ
By Name
ÂÂ
By Office
ÂÂ
Financial Report Log
ÂÂ
ÂÂ
ÂÂ
   Search Other Reports
ÂÂ
Business
Transaction Reports
ÂÂ
Campaign Reports
ÂÂ
Personal Financial Reports & Affidavits
ÂÂ
Lobbyist Reports
ÂÂ
Late/Non-Filer Reports
ÂÂ
Vendor Gifts Reports
ÂÂ
CFC Main Search
ÂÂ
CFC Home Page: Factor w/ 2 levels "Â","Search Returned No Results.": 1 1 1 1 1 1 1 1 1 1 ...
..$ FINANCIAL REPORTS - SEARCH RESULTS
Search Returned No Results. : Factor w/ 15 levels "Â"," \r\n    Search Financial\r\n  \r\n By Name\r\n  \r\n By Office\r\n  \r"| __truncated__,..: 2 4 6 7 11 1 3 5 8 14 ...
$ NULL:'data.frame': 14 obs. of 2 variables:
..$ Â : Factor w/ 1 level "Â": 1 1 1 1 1 1 1 1 1 1 ...
..$ ÂÂ
   Search Financial
ÂÂ
By Name
ÂÂ
By Office
ÂÂ
Financial Report Log
ÂÂ
ÂÂ
ÂÂ
   Search Other Reports
ÂÂ
Business
Transaction Reports
ÂÂ
Campaign Reports
ÂÂ
Personal Financial Reports & Affidavits
ÂÂ
Lobbyist Reports
ÂÂ
Late/Non-Filer Reports
ÂÂ
Vendor Gifts Reports
ÂÂ
CFC Main Search
ÂÂ
CFC Home Page: Factor w/ 14 levels "Â","   Search Other Reports",..: 3 5 6 10 1 2 4 7 13 12 ...
$ NULL:'data.frame': 13 obs. of 2 variables:
..$ Â : Factor w/ 1 level "Â": 1 1 1 1 1 1 1 1 1 1 ...
..$    Search Financial: Factor w/ 13 levels "Â","   Search Other Reports",..: 4 5 9 1 2 3 6 12 11 10 ...
$ NULL: NULLIf we detect “Search Returned No Results.” we can go ahead and cancel whatever extraction function is running. Trying an easier search term to see what results. We may be able to increment multiple page results as well.
q2<- ConstructFinancialQuery("Johnson")
Error in paste("http://media.ethics.ga.gov/search/Financial/Financial_BYNameResults.aspx?LastName=", :
argument "firstname" is missing, with no defaultRun successful.
str(q2)
List of 7
$ NULL :'data.frame': 264 obs. of 3 variables:
..$ V1: Factor w/ 7 levels "","Â"," \r\n \r\n  \r\n    Search Financial\r\n  \r\n By Name\r\n "| __truncated__,..: 1 4 3 2 2 2 2 2 2 2 ...
..$ V2: Factor w/ 259 levels "Â"," \r\n    Search Financial\r\n  \r\n By Name\r\n  \r\n By Office\r\n  \r"| __truncated__,..: NA NA 13 2 4 6 7 12 1 3 ...
..$ V3: Factor w/ 242 levels "#1 BROAD STREET, STE. #102 ELLIJAY, GA 30540",..: NA NA NA NA NA NA NA NA NA NA ...
$ NULL : NULL
$ NULL :'data.frame': 261 obs. of 3 variables:
..$ V1: Factor w/ 4 levels "Â","Action","ActionFilerAddress\r\n\t\t\r\n View Details\r\n \r\n "| __truncated__,..: 1 1 1 1 1 1 1 1 1 1 ...
..$ V2: Factor w/ 258 levels "Â"," \r\n    Search Financial\r\n  \r\n By Name\r\n  \r\n By Office\r\n  \r"| __truncated__,..: 2 4 6 7 12 1 3 5 8 257 ...
..$ V3: Factor w/ 242 levels "#1 BROAD STREET, STE. #102 ELLIJAY, GA 30540",..: NA NA NA NA NA NA NA NA NA NA ...
$ NULL :'data.frame': 14 obs. of 2 variables:
..$ Â : Factor w/ 1 level "Â": 1 1 1 1 1 1 1 1 1 1 ...
..$ ÂÂ
   Search Financial
ÂÂ
By Name
ÂÂ
By Office
ÂÂ
Financial Report Log
ÂÂ
ÂÂ
ÂÂ
   Search Other Reports
ÂÂ
Business
Transaction Reports
ÂÂ
Campaign Reports
ÂÂ
Personal Financial Reports & Affidavits
ÂÂ
Lobbyist Reports
ÂÂ
Late/Non-Filer Reports
ÂÂ
Vendor Gifts Reports
ÂÂ
CFC Main Search
ÂÂ
CFC Home Page: Factor w/ 14 levels "Â","   Search Other Reports",..: 3 5 6 10 1 2 4 7 13 12 ...
$ NULL :'data.frame': 13 obs. of 2 variables:
..$ Â : Factor w/ 1 level "Â": 1 1 1 1 1 1 1 1 1 1 ...
..$    Search Financial: Factor w/ 13 levels "Â","   Search Other Reports",..: 4 5 9 1 2 3 6 12 11 10 ...
$ NULL :'data.frame': 246 obs. of 3 variables:
..$ V1: Factor w/ 3 levels "Action","ActionFilerAddress\r\n\t\t\r\n View Details\r\n \r\n "| __truncated__,..: 2 1 3 3 3 3 3 3 3 3 ...
..$ V2: Factor w/ 243 levels "Filer","Johnson-Green , Tabitha Antionette",..: NA 1 13 12 14 223 15 16 17 6 ...
..$ V3: Factor w/ 242 levels "#1 BROAD STREET, STE. #102 ELLIJAY, GA 30540",..: NA 205 231 63 26 62 210 102 98 197 ...
$ ctl00_ContentPlaceHolder1_GridView1:'data.frame': 244 obs. of 3 variables:
..$ Action : Factor w/ 1 level "View Details": 1 1 1 1 1 1 1 1 1 1 ...
..$ Filer : Factor w/ 242 levels "Johnson-Green , Tabitha Antionette",..: 12 11 13 222 14 15 16 5 17 6 ...
..$ Address: Factor w/ 241 levels "#1 BROAD STREET, STE. #102 ELLIJAY, GA 30540",..: 230 63 26 62 209 102 98 197 81 91 ...Looks like the sixth and seventh list elements return the results.
Obviously these can be geocoded pretty easily.
Testing…
tqclean<- tqw[[-3]]
Error in tqw[[-3]] :
attempt to select more than one element in get1index <real>